#!/usr/bin/env python
# -*- encoding: utf-8 -*-
# Project: spd-sxmcc
"""
@author: lyndon
@time Created on 2019/2/28 17:15
@desc
"""
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('mysql+mysqldb://root:newpasswd@192.168.100.161:3306/OLINGO?charset=utf8')
Base = declarative_base()
print(engine)

db_conn = engine.connect()

sql = """select * from BusinessPartner where id = '1'"""

res = db_conn.execute(sql).fetchall()
print(res)

blk = input(">>>>")

